A Data Warehouse Conceptual Data Model for Multidimensional Aggregation: a preliminary report
نویسندگان
چکیده
This paper presents a proposal for a Data Warehouse Conceptual Data Model which allows for the description of both the relevant aggregated entities of the domain| together with their properties and their relationships with other relevant entities|and the relevant dimensions involved in building the aggregated entities. The proposed Data Warehouse Conceptual Data Model is able to capture the database schemata expressed in the most interesting traditional Semantic Data Models and Object-Oriented Data Models; it is able to introduce complex descriptions of the structure of aggregated entities and multiply hierarchically organised dimensions; it is based on Description Logics, a class of formalisms for which it is possible to study the expressivity in relation with decidability of reasoning problems and completeness of algorithms; it supports the most important reasoning services for the basic Data Warehouse operations.
منابع مشابه
A Conceptual Model for Multidimensional Data
This paper introduces a Conceptual Data Model for Data Warehouse including multidimensional aggregation. It is based on Entity-Relationships data model. The conceptual data model gracefully extends standard Entity-Relationship data model with multidimensional aggregated entities. The model has a clear mathematical theoretic semantics grounded on standard ER semantics and the GMD logic-based mul...
متن کاملSpecifying Aggregation Functions in Multidimensional Models with OCL
Multidimensional models are at the core of data warehouse systems, since they allow decision makers to early define the relevant information and queries that are required to satisfy their information needs. The use of aggregation functions is a cornerstone in the definition of these multidimensional queries. However, current proposals for multidimensional modeling lack the mechanisms to define ...
متن کاملCombining objects with rules to represent aggregation knowledge in data warehouse and OLAP systems
Data warehouses are based on multidimensional modeling. Using On-Line Analytical Processing (OLAP) tools, decision makers navigate through and analyze multidimensional data. Typically, users need to analyze data at different aggregation levels (using roll-up and drill-down functions). Therefore, aggregation knowledge should be adequately represented in conceptual multidimensional models, and ma...
متن کاملA Data Warehouse Conceptual Data Model for Multidimensional Aggregation
This paper presents a proposal for a Data Warehouse Conceptual Data (CDWDM) Model which allows for the description of both the relevant aggregated entities of the domain—together with their properties and their relationships with other relevant entities—and the relevant dimensions involved in building the aggregated entities. The proposed CDWDM is able to capture the database schemata expressed...
متن کاملData warehouse schemas: a software engineering approach towards an efficient modeling of complex, dynamic conceptual schemas
In contrast to most traditional information systems which are based on a static, consistent view of transactional data, a data warehouse comprises several stages of data integration and data aggregation. Hence, the conceptual design of data warehouses addresses not only data structures, but also derivation paths. Integration and aggregation paths result in highly complex schemas and consistent ...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 1999